package com.ls.data.mapper;

import com.ls.interPojo.PhoneAttribution;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author 段成
 * @date 2020/1/9 - 18:52
 */
@Mapper
public interface PhoneAttributionMapper {
    @Select("select * from tb_phoneAttribution where phone = #{value}")
    PhoneAttribution getDataByPhone(String phone);

    @Insert("INSERT INTO `lingsun2`.`tb_phoneAttribution` (`province`, `city`, `areacode`, `zip`, `company`, `card`, `phone`) VALUES ( #{province}, #{city}, #{areacode}, #{zip}, #{company}, #{card}, #{phone})")
    void insertData(PhoneAttribution insertData);
}
